﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="CDmDjkCustomerBaseInfo" targetNamespace="http://tempuri.org/CDmDjkCustomerBaseInfo.xsd" xmlns:mstns="http://tempuri.org/CDmDjkCustomerBaseInfo.xsd" xmlns="http://tempuri.org/CDmDjkCustomerBaseInfo.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="dijiekeConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="dijiekeConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.msBsc.Xsd.DataTds.Properties.Settings.GlobalReference.Default.dijiekeConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="RealDataBaseConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="RealDataBaseConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.msBsc.Xsd.DataTds.Properties.Settings.GlobalReference.Default.RealDataBaseConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DJK_CUSTOMER_BASEINFOTableAdapter" GeneratorDataComponentClassName="DJK_CUSTOMER_BASEINFOTableAdapter" Name="DJK_CUSTOMER_BASEINFO" UserDataComponentName="DJK_CUSTOMER_BASEINFOTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dijiekeConnectionString (Settings)" DbObjectName="dijieke.dbo.DJK_CUSTOMER_BASEINFO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DJK_CUSTOMER_BASEINFO] WHERE (([CUSTOMER_BASEINFO_ID] = @Original_CUSTOMER_BASEINFO_ID) AND ((@IsNull_CUSTOMER_BASEINFO_NAME = 1 AND [CUSTOMER_BASEINFO_NAME] IS NULL) OR ([CUSTOMER_BASEINFO_NAME] = @Original_CUSTOMER_BASEINFO_NAME)) AND ((@IsNull_CUSTOMER_BASEINFO_GENDER = 1 AND [CUSTOMER_BASEINFO_GENDER] IS NULL) OR ([CUSTOMER_BASEINFO_GENDER] = @Original_CUSTOMER_BASEINFO_GENDER)) AND ((@IsNull_CUSTOMER_CREDENTIALS_TYPE = 1 AND [CUSTOMER_CREDENTIALS_TYPE] IS NULL) OR ([CUSTOMER_CREDENTIALS_TYPE] = @Original_CUSTOMER_CREDENTIALS_TYPE)) AND ((@IsNull_CUSTOMER_CREDENTIALS_NO = 1 AND [CUSTOMER_CREDENTIALS_NO] IS NULL) OR ([CUSTOMER_CREDENTIALS_NO] = @Original_CUSTOMER_CREDENTIALS_NO)) AND ((@IsNull_CUSTOMER_DISTINATION_ID = 1 AND [CUSTOMER_DISTINATION_ID] IS NULL) OR ([CUSTOMER_DISTINATION_ID] = @Original_CUSTOMER_DISTINATION_ID)) AND ((@IsNull_CUSTOMER_CITY_ID = 1 AND [CUSTOMER_CITY_ID] IS NULL) OR ([CUSTOMER_CITY_ID] = @Original_CUSTOMER_CITY_ID)) AND ((@IsNull_CUSTOMER_COUNTRY_ID = 1 AND [CUSTOMER_COUNTRY_ID] IS NULL) OR ([CUSTOMER_COUNTRY_ID] = @Original_CUSTOMER_COUNTRY_ID)) AND ((@IsNull_CUSTOMER_BASEINFO_BIRTH = 1 AND [CUSTOMER_BASEINFO_BIRTH] IS NULL) OR ([CUSTOMER_BASEINFO_BIRTH] = @Original_CUSTOMER_BASEINFO_BIRTH)) AND ((@IsNull_CUSTOMER_BASEINFO_PHONE = 1 AND [CUSTOMER_BASEINFO_PHONE] IS NULL) OR ([CUSTOMER_BASEINFO_PHONE] = @Original_CUSTOMER_BASEINFO_PHONE)) AND ((@IsNull_CUSTOMER_BASEINFO_MOBILE = 1 AND [CUSTOMER_BASEINFO_MOBILE] IS NULL) OR ([CUSTOMER_BASEINFO_MOBILE] = @Original_CUSTOMER_BASEINFO_MOBILE)) AND ((@IsNull_CUSTOMER_BASEINFO_QQ = 1 AND [CUSTOMER_BASEINFO_QQ] IS NULL) OR ([CUSTOMER_BASEINFO_QQ] = @Original_CUSTOMER_BASEINFO_QQ)) AND ((@IsNull_CUSTOMER_BASEINFO_FAX = 1 AND [CUSTOMER_BASEINFO_FAX] IS NULL) OR ([CUSTOMER_BASEINFO_FAX] = @Original_CUSTOMER_BASEINFO_FAX)) AND ((@IsNull_CUSTOMER_WECHAT_NO = 1 AND [CUSTOMER_WECHAT_NO] IS NULL) OR ([CUSTOMER_WECHAT_NO] = @Original_CUSTOMER_WECHAT_NO)) AND ((@IsNull_CUSTOMER_BASEINFO_EMAIL = 1 AND [CUSTOMER_BASEINFO_EMAIL] IS NULL) OR ([CUSTOMER_BASEINFO_EMAIL] = @Original_CUSTOMER_BASEINFO_EMAIL)) AND ((@IsNull_CUSTOMER_BASEINFO_INTRO = 1 AND [CUSTOMER_BASEINFO_INTRO] IS NULL) OR ([CUSTOMER_BASEINFO_INTRO] = @Original_CUSTOMER_BASEINFO_INTRO)) AND ([BASEINFO_IS_DELETED] = @Original_BASEINFO_IS_DELETED) AND ([BASEINFO_IS_DISPLAY] = @Original_BASEINFO_IS_DISPLAY) AND ((@IsNull_CUSTOMER_BASEINFO_RMK = 1 AND [CUSTOMER_BASEINFO_RMK] IS NULL) OR ([CUSTOMER_BASEINFO_RMK] = @Original_CUSTOMER_BASEINFO_RMK)) AND ((@IsNull_CUSTOMER_BANK_ACCOUNT = 1 AND [CUSTOMER_BANK_ACCOUNT] IS NULL) OR ([CUSTOMER_BANK_ACCOUNT] = @Original_CUSTOMER_BANK_ACCOUNT)) AND ((@IsNull_CUSTOMER_BANK_TYPE = 1 AND [CUSTOMER_BANK_TYPE] IS NULL) OR ([CUSTOMER_BANK_TYPE] = @Original_CUSTOMER_BANK_TYPE)) AND ((@IsNull_CUSTOMER_ACCOUNT_NAME = 1 AND [CUSTOMER_ACCOUNT_NAME] IS NULL) OR ([CUSTOMER_ACCOUNT_NAME] = @Original_CUSTOMER_ACCOUNT_NAME)) AND ((@IsNull_CUSTOMER_BANK_NAME = 1 AND [CUSTOMER_BANK_NAME] IS NULL) OR ([CUSTOMER_BANK_NAME] = @Original_CUSTOMER_BANK_NAME)) AND ((@IsNull_CUSTOMER_BANK_CCY = 1 AND [CUSTOMER_BANK_CCY] IS NULL) OR ([CUSTOMER_BANK_CCY] = @Original_CUSTOMER_BANK_CCY)) AND ((@IsNull_CUSTOMER_ALIPAY_ACCOUNT = 1 AND [CUSTOMER_ALIPAY_ACCOUNT] IS NULL) OR ([CUSTOMER_ALIPAY_ACCOUNT] = @Original_CUSTOMER_ALIPAY_ACCOUNT)) AND ((@IsNull_CUSTOMER_PAY_INNERPWD = 1 AND [CUSTOMER_PAY_INNERPWD] IS NULL) OR ([CUSTOMER_PAY_INNERPWD] = @Original_CUSTOMER_PAY_INNERPWD)) AND ((@IsNull_CUSTOMER_FIRST_BINDBANKDT = 1 AND [CUSTOMER_FIRST_BINDBANKDT] IS NULL) OR ([CUSTOMER_FIRST_BINDBANKDT] = @Original_CUSTOMER_FIRST_BINDBANKDT)) AND ((@IsNull_CUSTOMER_FIRST_BINDALIPAYDT = 1 AND [CUSTOMER_FIRST_BINDALIPAYDT] IS NULL) OR ([CUSTOMER_FIRST_BINDALIPAYDT] = @Original_CUSTOMER_FIRST_BINDALIPAYDT)) AND ((@IsNull_CUSTOMER_LAST_MDBANKDT = 1 AND [CUSTOMER_LAST_MDBANKDT] IS NULL) OR ([CUSTOMER_LAST_MDBANKDT] = @Original_CUSTOMER_LAST_MDBANKDT)) AND ((@IsNull_CUSTOMER_LAST_MDALIPAYDT = 1 AND [CUSTOMER_LAST_MDALIPAYDT] IS NULL) OR ([CUSTOMER_LAST_MDALIPAYDT] = @Original_CUSTOMER_LAST_MDALIPAYDT)) AND ((@IsNull_CUSTOMER_DRAWALS_ACCOUNT = 1 AND [CUSTOMER_DRAWALS_ACCOUNT] IS NULL) OR ([CUSTOMER_DRAWALS_ACCOUNT] = @Original_CUSTOMER_DRAWALS_ACCOUNT)) AND ((@IsNull_CUSTOMER_SECDEP_ACCOUNT = 1 AND [CUSTOMER_SECDEP_ACCOUNT] IS NULL) OR ([CUSTOMER_SECDEP_ACCOUNT] = @Original_CUSTOMER_SECDEP_ACCOUNT)) AND ((@IsNull_CUSTOMER_LAST_DRAWALSDT = 1 AND [CUSTOMER_LAST_DRAWALSDT] IS NULL) OR ([CUSTOMER_LAST_DRAWALSDT] = @Original_CUSTOMER_LAST_DRAWALSDT)) AND ((@IsNull_SYS_FOR_CREFY = 1 AND [SYS_FOR_CREFY] IS NULL) OR ([SYS_FOR_CREFY] = @Original_SYS_FOR_CREFY)) AND ((@IsNull_SYS_FOR_CREFY_DT = 1 AND [SYS_FOR_CREFY_DT] IS NULL) OR ([SYS_FOR_CREFY_DT] = @Original_SYS_FOR_CREFY_DT)) AND ((@IsNull_CUSTOMER_CREFY_DT = 1 AND [CUSTOMER_CREFY_DT] IS NULL) OR ([CUSTOMER_CREFY_DT] = @Original_CUSTOMER_CREFY_DT)) AND ((@IsNull_CUSTOMER_IS_CREFY = 1 AND [CUSTOMER_IS_CREFY] IS NULL) OR ([CUSTOMER_IS_CREFY] = @Original_CUSTOMER_IS_CREFY)) AND ((@IsNull_CUSTOMER_CREFY_FAILD_NUM = 1 AND [CUSTOMER_CREFY_FAILD_NUM] IS NULL) OR ([CUSTOMER_CREFY_FAILD_NUM] = @Original_CUSTOMER_CREFY_FAILD_NUM)) AND ((@IsNull_CUSTOMER_CREFY_LAST_DT = 1 AND [CUSTOMER_CREFY_LAST_DT] IS NULL) OR ([CUSTOMER_CREFY_LAST_DT] = @Original_CUSTOMER_CREFY_LAST_DT)) AND ((@IsNull_CUSTOMER_CREFY_STATUS = 1 AND [CUSTOMER_CREFY_STATUS] IS NULL) OR ([CUSTOMER_CREFY_STATUS] = @Original_CUSTOMER_CREFY_STATUS)) AND ((@IsNull_CUSTOMER_CLEAR_ALIPAY_DT = 1 AND [CUSTOMER_CLEAR_ALIPAY_DT] IS NULL) OR ([CUSTOMER_CLEAR_ALIPAY_DT] = @Original_CUSTOMER_CLEAR_ALIPAY_DT)) AND ((@IsNull_DENY_REASON = 1 AND [DENY_REASON] IS NULL) OR ([DENY_REASON] = @Original_DENY_REASON)) AND ((@IsNull_DOCUMENT_IMAGE = 1 AND [DOCUMENT_IMAGE] IS NULL) OR ([DOCUMENT_IMAGE] = @Original_DOCUMENT_IMAGE)) AND ((@IsNull_AGENT_DISTINATION_ID = 1 AND [AGENT_DISTINATION_ID] IS NULL) OR ([AGENT_DISTINATION_ID] = @Original_AGENT_DISTINATION_ID)) AND ((@IsNull_AGENT_CITY_ID = 1 AND [AGENT_CITY_ID] IS NULL) OR ([AGENT_CITY_ID] = @Original_AGENT_CITY_ID)) AND ((@IsNull_AGENT_COUNTRY_ID = 1 AND [AGENT_COUNTRY_ID] IS NULL) OR ([AGENT_COUNTRY_ID] = @Original_AGENT_COUNTRY_ID)) AND ((@IsNull_CUSTOMER_SERVICE_AREA = 1 AND [CUSTOMER_SERVICE_AREA] IS NULL) OR ([CUSTOMER_SERVICE_AREA] = @Original_CUSTOMER_SERVICE_AREA)) AND ((@IsNull_IS_DRIVING_LICENSE = 1 AND [IS_DRIVING_LICENSE] IS NULL) OR ([IS_DRIVING_LICENSE] = @Original_IS_DRIVING_LICENSE)) AND ((@IsNull_IS_QUALIFICATION_CERTIFICATE = 1 AND [IS_QUALIFICATION_CERTIFICATE] IS NULL) OR ([IS_QUALIFICATION_CERTIFICATE] = @Original_IS_QUALIFICATION_CERTIFICATE)) AND ((@IsNull_IS_XINGSI_LICENSE = 1 AND [IS_XINGSI_LICENSE] IS NULL) OR ([IS_XINGSI_LICENSE] = @Original_IS_XINGSI_LICENSE)) AND ((@IsNull_IS_TRANSPORT_CERTIFICATE = 1 AND [IS_TRANSPORT_CERTIFICATE] IS NULL) OR ([IS_TRANSPORT_CERTIFICATE] = @Original_IS_TRANSPORT_CERTIFICATE)) AND ((@IsNull_IS_RECORD_CARD = 1 AND [IS_RECORD_CARD] IS NULL) OR ([IS_RECORD_CARD] = @Original_IS_RECORD_CARD)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_BASEINFO_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_BASEINFO_NAME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_NAME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_BASEINFO_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_BASEINFO_GENDER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_GENDER" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_BASEINFO_GENDER" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_GENDER" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_CREDENTIALS_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_CREDENTIALS_TYPE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CUSTOMER_CREDENTIALS_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_CREDENTIALS_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_CREDENTIALS_NO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_CREDENTIALS_NO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_CREDENTIALS_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_CREDENTIALS_NO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_DISTINATION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_DISTINATION_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_DISTINATION_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_DISTINATION_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_CITY_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_CITY_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_CITY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_CITY_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_COUNTRY_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_COUNTRY_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_COUNTRY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_COUNTRY_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_BASEINFO_BIRTH" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_BIRTH" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CUSTOMER_BASEINFO_BIRTH" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_BIRTH" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_BASEINFO_PHONE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_PHONE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_BASEINFO_PHONE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_PHONE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_BASEINFO_MOBILE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_MOBILE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_BASEINFO_MOBILE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_MOBILE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_BASEINFO_QQ" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_QQ" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_BASEINFO_QQ" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_QQ" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_BASEINFO_FAX" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_FAX" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_BASEINFO_FAX" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_FAX" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_WECHAT_NO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_WECHAT_NO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_WECHAT_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_WECHAT_NO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_BASEINFO_EMAIL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_EMAIL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_BASEINFO_EMAIL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_EMAIL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_BASEINFO_INTRO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_INTRO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_BASEINFO_INTRO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_INTRO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_BASEINFO_IS_DELETED" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="BASEINFO_IS_DELETED" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_BASEINFO_IS_DISPLAY" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="BASEINFO_IS_DISPLAY" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_BASEINFO_RMK" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_RMK" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_BASEINFO_RMK" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_RMK" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_BANK_ACCOUNT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BANK_ACCOUNT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_BANK_ACCOUNT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BANK_ACCOUNT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_BANK_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BANK_TYPE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_BANK_TYPE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BANK_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_ACCOUNT_NAME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_ACCOUNT_NAME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_ACCOUNT_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_ACCOUNT_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_BANK_NAME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BANK_NAME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_BANK_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BANK_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_BANK_CCY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BANK_CCY" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CUSTOMER_BANK_CCY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BANK_CCY" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_ALIPAY_ACCOUNT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_ALIPAY_ACCOUNT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_ALIPAY_ACCOUNT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_ALIPAY_ACCOUNT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_PAY_INNERPWD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_PAY_INNERPWD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_PAY_INNERPWD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_PAY_INNERPWD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_FIRST_BINDBANKDT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_FIRST_BINDBANKDT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CUSTOMER_FIRST_BINDBANKDT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_FIRST_BINDBANKDT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_FIRST_BINDALIPAYDT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_FIRST_BINDALIPAYDT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CUSTOMER_FIRST_BINDALIPAYDT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_FIRST_BINDALIPAYDT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_LAST_MDBANKDT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_LAST_MDBANKDT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CUSTOMER_LAST_MDBANKDT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_LAST_MDBANKDT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_LAST_MDALIPAYDT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_LAST_MDALIPAYDT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CUSTOMER_LAST_MDALIPAYDT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_LAST_MDALIPAYDT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_DRAWALS_ACCOUNT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_DRAWALS_ACCOUNT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CUSTOMER_DRAWALS_ACCOUNT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CUSTOMER_DRAWALS_ACCOUNT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_SECDEP_ACCOUNT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_SECDEP_ACCOUNT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CUSTOMER_SECDEP_ACCOUNT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CUSTOMER_SECDEP_ACCOUNT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_LAST_DRAWALSDT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_LAST_DRAWALSDT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CUSTOMER_LAST_DRAWALSDT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_LAST_DRAWALSDT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SYS_FOR_CREFY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SYS_FOR_CREFY" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_SYS_FOR_CREFY" Precision="10" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="SYS_FOR_CREFY" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SYS_FOR_CREFY_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SYS_FOR_CREFY_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_SYS_FOR_CREFY_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="SYS_FOR_CREFY_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_CREFY_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_CREFY_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CUSTOMER_CREFY_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_CREFY_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_IS_CREFY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_IS_CREFY" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_CUSTOMER_IS_CREFY" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="CUSTOMER_IS_CREFY" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_CREFY_FAILD_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_CREFY_FAILD_NUM" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CUSTOMER_CREFY_FAILD_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_CREFY_FAILD_NUM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_CREFY_LAST_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_CREFY_LAST_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CUSTOMER_CREFY_LAST_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_CREFY_LAST_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_CREFY_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_CREFY_STATUS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CUSTOMER_CREFY_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_CREFY_STATUS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_CLEAR_ALIPAY_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_CLEAR_ALIPAY_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CUSTOMER_CLEAR_ALIPAY_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_CLEAR_ALIPAY_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DENY_REASON" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DENY_REASON" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DENY_REASON" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DENY_REASON" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DOCUMENT_IMAGE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOCUMENT_IMAGE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DOCUMENT_IMAGE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOCUMENT_IMAGE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AGENT_DISTINATION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AGENT_DISTINATION_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AGENT_DISTINATION_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AGENT_DISTINATION_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AGENT_CITY_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AGENT_CITY_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AGENT_CITY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AGENT_CITY_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AGENT_COUNTRY_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AGENT_COUNTRY_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AGENT_COUNTRY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AGENT_COUNTRY_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_SERVICE_AREA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_SERVICE_AREA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_SERVICE_AREA" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_SERVICE_AREA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IS_DRIVING_LICENSE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IS_DRIVING_LICENSE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IS_DRIVING_LICENSE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_DRIVING_LICENSE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IS_QUALIFICATION_CERTIFICATE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IS_QUALIFICATION_CERTIFICATE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IS_QUALIFICATION_CERTIFICATE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_QUALIFICATION_CERTIFICATE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IS_XINGSI_LICENSE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IS_XINGSI_LICENSE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IS_XINGSI_LICENSE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_XINGSI_LICENSE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IS_TRANSPORT_CERTIFICATE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IS_TRANSPORT_CERTIFICATE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IS_TRANSPORT_CERTIFICATE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_TRANSPORT_CERTIFICATE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IS_RECORD_CARD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IS_RECORD_CARD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IS_RECORD_CARD" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_RECORD_CARD" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DJK_CUSTOMER_BASEINFO] ([CUSTOMER_BASEINFO_ID], [CUSTOMER_BASEINFO_NAME], [CUSTOMER_BASEINFO_GENDER], [CUSTOMER_CREDENTIALS_TYPE], [CUSTOMER_CREDENTIALS_NO], [CUSTOMER_DISTINATION_ID], [CUSTOMER_CITY_ID], [CUSTOMER_COUNTRY_ID], [CUSTOMER_BASEINFO_BIRTH], [CUSTOMER_BASEINFO_PHONE], [CUSTOMER_BASEINFO_MOBILE], [CUSTOMER_BASEINFO_QQ], [CUSTOMER_BASEINFO_FAX], [CUSTOMER_WECHAT_NO], [CUSTOMER_BASEINFO_EMAIL], [CUSTOMER_BASEINFO_INTRO], [BASEINFO_IS_DELETED], [BASEINFO_IS_DISPLAY], [CUSTOMER_BASEINFO_RMK], [CUSTOMER_BANK_ACCOUNT], [CUSTOMER_BANK_TYPE], [CUSTOMER_ACCOUNT_NAME], [CUSTOMER_BANK_NAME], [CUSTOMER_BANK_CCY], [CUSTOMER_ALIPAY_ACCOUNT], [CUSTOMER_PAY_INNERPWD], [CUSTOMER_FIRST_BINDBANKDT], [CUSTOMER_FIRST_BINDALIPAYDT], [CUSTOMER_LAST_MDBANKDT], [CUSTOMER_LAST_MDALIPAYDT], [CUSTOMER_DRAWALS_ACCOUNT], [CUSTOMER_SECDEP_ACCOUNT], [CUSTOMER_LAST_DRAWALSDT], [SYS_FOR_CREFY], [SYS_FOR_CREFY_DT], [CUSTOMER_CREFY_DT], [CUSTOMER_IS_CREFY], [CUSTOMER_CREFY_FAILD_NUM], [CUSTOMER_CREFY_LAST_DT], [CUSTOMER_CREFY_STATUS], [CUSTOMER_CLEAR_ALIPAY_DT], [DENY_REASON], [DOCUMENT_IMAGE], [AGENT_DISTINATION_ID], [AGENT_CITY_ID], [AGENT_COUNTRY_ID], [CUSTOMER_SERVICE_AREA], [IS_DRIVING_LICENSE], [IS_QUALIFICATION_CERTIFICATE], [IS_XINGSI_LICENSE], [IS_TRANSPORT_CERTIFICATE], [IS_RECORD_CARD]) VALUES (@CUSTOMER_BASEINFO_ID, @CUSTOMER_BASEINFO_NAME, @CUSTOMER_BASEINFO_GENDER, @CUSTOMER_CREDENTIALS_TYPE, @CUSTOMER_CREDENTIALS_NO, @CUSTOMER_DISTINATION_ID, @CUSTOMER_CITY_ID, @CUSTOMER_COUNTRY_ID, @CUSTOMER_BASEINFO_BIRTH, @CUSTOMER_BASEINFO_PHONE, @CUSTOMER_BASEINFO_MOBILE, @CUSTOMER_BASEINFO_QQ, @CUSTOMER_BASEINFO_FAX, @CUSTOMER_WECHAT_NO, @CUSTOMER_BASEINFO_EMAIL, @CUSTOMER_BASEINFO_INTRO, @BASEINFO_IS_DELETED, @BASEINFO_IS_DISPLAY, @CUSTOMER_BASEINFO_RMK, @CUSTOMER_BANK_ACCOUNT, @CUSTOMER_BANK_TYPE, @CUSTOMER_ACCOUNT_NAME, @CUSTOMER_BANK_NAME, @CUSTOMER_BANK_CCY, @CUSTOMER_ALIPAY_ACCOUNT, @CUSTOMER_PAY_INNERPWD, @CUSTOMER_FIRST_BINDBANKDT, @CUSTOMER_FIRST_BINDALIPAYDT, @CUSTOMER_LAST_MDBANKDT, @CUSTOMER_LAST_MDALIPAYDT, @CUSTOMER_DRAWALS_ACCOUNT, @CUSTOMER_SECDEP_ACCOUNT, @CUSTOMER_LAST_DRAWALSDT, @SYS_FOR_CREFY, @SYS_FOR_CREFY_DT, @CUSTOMER_CREFY_DT, @CUSTOMER_IS_CREFY, @CUSTOMER_CREFY_FAILD_NUM, @CUSTOMER_CREFY_LAST_DT, @CUSTOMER_CREFY_STATUS, @CUSTOMER_CLEAR_ALIPAY_DT, @DENY_REASON, @DOCUMENT_IMAGE, @AGENT_DISTINATION_ID, @AGENT_CITY_ID, @AGENT_COUNTRY_ID, @CUSTOMER_SERVICE_AREA, @IS_DRIVING_LICENSE, @IS_QUALIFICATION_CERTIFICATE, @IS_XINGSI_LICENSE, @IS_TRANSPORT_CERTIFICATE, @IS_RECORD_CARD);
SELECT CUSTOMER_BASEINFO_ID, CUSTOMER_BASEINFO_NAME, CUSTOMER_BASEINFO_GENDER, CUSTOMER_CREDENTIALS_TYPE, CUSTOMER_CREDENTIALS_NO, CUSTOMER_DISTINATION_ID, CUSTOMER_CITY_ID, CUSTOMER_COUNTRY_ID, CUSTOMER_BASEINFO_BIRTH, CUSTOMER_BASEINFO_PHONE, CUSTOMER_BASEINFO_MOBILE, CUSTOMER_BASEINFO_QQ, CUSTOMER_BASEINFO_FAX, CUSTOMER_WECHAT_NO, CUSTOMER_BASEINFO_EMAIL, CUSTOMER_BASEINFO_INTRO, BASEINFO_IS_DELETED, BASEINFO_IS_DISPLAY, CUSTOMER_BASEINFO_RMK, CUSTOMER_BANK_ACCOUNT, CUSTOMER_BANK_TYPE, CUSTOMER_ACCOUNT_NAME, CUSTOMER_BANK_NAME, CUSTOMER_BANK_CCY, CUSTOMER_ALIPAY_ACCOUNT, CUSTOMER_PAY_INNERPWD, CUSTOMER_FIRST_BINDBANKDT, CUSTOMER_FIRST_BINDALIPAYDT, CUSTOMER_LAST_MDBANKDT, CUSTOMER_LAST_MDALIPAYDT, CUSTOMER_DRAWALS_ACCOUNT, CUSTOMER_SECDEP_ACCOUNT, CUSTOMER_LAST_DRAWALSDT, SYS_FOR_CREFY, SYS_FOR_CREFY_DT, CUSTOMER_CREFY_DT, CUSTOMER_IS_CREFY, CUSTOMER_CREFY_FAILD_NUM, CUSTOMER_CREFY_LAST_DT, CUSTOMER_CREFY_STATUS, CUSTOMER_CLEAR_ALIPAY_DT, DENY_REASON, DOCUMENT_IMAGE, AGENT_DISTINATION_ID, AGENT_CITY_ID, AGENT_COUNTRY_ID, CUSTOMER_SERVICE_AREA, IS_DRIVING_LICENSE, IS_QUALIFICATION_CERTIFICATE, IS_XINGSI_LICENSE, IS_TRANSPORT_CERTIFICATE, IS_RECORD_CARD FROM DJK_CUSTOMER_BASEINFO WHERE (CUSTOMER_BASEINFO_ID = @CUSTOMER_BASEINFO_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_BASEINFO_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_BASEINFO_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_BASEINFO_GENDER" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_GENDER" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CUSTOMER_CREDENTIALS_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_CREDENTIALS_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_CREDENTIALS_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_CREDENTIALS_NO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_DISTINATION_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_DISTINATION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_CITY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_CITY_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_COUNTRY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_COUNTRY_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CUSTOMER_BASEINFO_BIRTH" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_BIRTH" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_BASEINFO_PHONE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_PHONE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_BASEINFO_MOBILE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_MOBILE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_BASEINFO_QQ" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_QQ" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_BASEINFO_FAX" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_FAX" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_WECHAT_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_WECHAT_NO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_BASEINFO_EMAIL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_EMAIL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_BASEINFO_INTRO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_INTRO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@BASEINFO_IS_DELETED" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="BASEINFO_IS_DELETED" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@BASEINFO_IS_DISPLAY" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="BASEINFO_IS_DISPLAY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_BASEINFO_RMK" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_RMK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_BANK_ACCOUNT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BANK_ACCOUNT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_BANK_TYPE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BANK_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_ACCOUNT_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_ACCOUNT_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_BANK_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BANK_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CUSTOMER_BANK_CCY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BANK_CCY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_ALIPAY_ACCOUNT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_ALIPAY_ACCOUNT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_PAY_INNERPWD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_PAY_INNERPWD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CUSTOMER_FIRST_BINDBANKDT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_FIRST_BINDBANKDT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CUSTOMER_FIRST_BINDALIPAYDT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_FIRST_BINDALIPAYDT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CUSTOMER_LAST_MDBANKDT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_LAST_MDBANKDT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CUSTOMER_LAST_MDALIPAYDT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_LAST_MDALIPAYDT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CUSTOMER_DRAWALS_ACCOUNT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CUSTOMER_DRAWALS_ACCOUNT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CUSTOMER_SECDEP_ACCOUNT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CUSTOMER_SECDEP_ACCOUNT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CUSTOMER_LAST_DRAWALSDT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_LAST_DRAWALSDT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@SYS_FOR_CREFY" Precision="10" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="SYS_FOR_CREFY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@SYS_FOR_CREFY_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="SYS_FOR_CREFY_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CUSTOMER_CREFY_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_CREFY_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@CUSTOMER_IS_CREFY" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="CUSTOMER_IS_CREFY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CUSTOMER_CREFY_FAILD_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_CREFY_FAILD_NUM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CUSTOMER_CREFY_LAST_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_CREFY_LAST_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CUSTOMER_CREFY_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_CREFY_STATUS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CUSTOMER_CLEAR_ALIPAY_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_CLEAR_ALIPAY_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DENY_REASON" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DENY_REASON" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DOCUMENT_IMAGE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOCUMENT_IMAGE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AGENT_DISTINATION_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AGENT_DISTINATION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AGENT_CITY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AGENT_CITY_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AGENT_COUNTRY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AGENT_COUNTRY_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_SERVICE_AREA" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_SERVICE_AREA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IS_DRIVING_LICENSE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_DRIVING_LICENSE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IS_QUALIFICATION_CERTIFICATE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_QUALIFICATION_CERTIFICATE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IS_XINGSI_LICENSE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_XINGSI_LICENSE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IS_TRANSPORT_CERTIFICATE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_TRANSPORT_CERTIFICATE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IS_RECORD_CARD" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_RECORD_CARD" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CUSTOMER_BASEINFO_ID, CUSTOMER_BASEINFO_NAME, CUSTOMER_BASEINFO_GENDER, CUSTOMER_CREDENTIALS_TYPE, CUSTOMER_CREDENTIALS_NO, CUSTOMER_DISTINATION_ID, CUSTOMER_CITY_ID, CUSTOMER_COUNTRY_ID, CUSTOMER_BASEINFO_BIRTH, CUSTOMER_BASEINFO_PHONE, CUSTOMER_BASEINFO_MOBILE, CUSTOMER_BASEINFO_QQ, CUSTOMER_BASEINFO_FAX, CUSTOMER_WECHAT_NO, CUSTOMER_BASEINFO_EMAIL, CUSTOMER_BASEINFO_INTRO, BASEINFO_IS_DELETED, BASEINFO_IS_DISPLAY, CUSTOMER_BASEINFO_RMK, CUSTOMER_BANK_ACCOUNT, CUSTOMER_BANK_TYPE, CUSTOMER_ACCOUNT_NAME, CUSTOMER_BANK_NAME, CUSTOMER_BANK_CCY, CUSTOMER_ALIPAY_ACCOUNT, CUSTOMER_PAY_INNERPWD, CUSTOMER_FIRST_BINDBANKDT, CUSTOMER_FIRST_BINDALIPAYDT, CUSTOMER_LAST_MDBANKDT, CUSTOMER_LAST_MDALIPAYDT, CUSTOMER_DRAWALS_ACCOUNT, CUSTOMER_SECDEP_ACCOUNT, CUSTOMER_LAST_DRAWALSDT, SYS_FOR_CREFY, SYS_FOR_CREFY_DT, CUSTOMER_CREFY_DT, CUSTOMER_IS_CREFY, CUSTOMER_CREFY_FAILD_NUM, CUSTOMER_CREFY_LAST_DT, CUSTOMER_CREFY_STATUS, CUSTOMER_CLEAR_ALIPAY_DT, DENY_REASON, DOCUMENT_IMAGE, AGENT_DISTINATION_ID, AGENT_CITY_ID, AGENT_COUNTRY_ID, CUSTOMER_SERVICE_AREA, IS_DRIVING_LICENSE, IS_QUALIFICATION_CERTIFICATE, IS_XINGSI_LICENSE, IS_TRANSPORT_CERTIFICATE, IS_RECORD_CARD FROM dbo.DJK_CUSTOMER_BASEINFO</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DJK_CUSTOMER_BASEINFO] SET [CUSTOMER_BASEINFO_ID] = @CUSTOMER_BASEINFO_ID, [CUSTOMER_BASEINFO_NAME] = @CUSTOMER_BASEINFO_NAME, [CUSTOMER_BASEINFO_GENDER] = @CUSTOMER_BASEINFO_GENDER, [CUSTOMER_CREDENTIALS_TYPE] = @CUSTOMER_CREDENTIALS_TYPE, [CUSTOMER_CREDENTIALS_NO] = @CUSTOMER_CREDENTIALS_NO, [CUSTOMER_DISTINATION_ID] = @CUSTOMER_DISTINATION_ID, [CUSTOMER_CITY_ID] = @CUSTOMER_CITY_ID, [CUSTOMER_COUNTRY_ID] = @CUSTOMER_COUNTRY_ID, [CUSTOMER_BASEINFO_BIRTH] = @CUSTOMER_BASEINFO_BIRTH, [CUSTOMER_BASEINFO_PHONE] = @CUSTOMER_BASEINFO_PHONE, [CUSTOMER_BASEINFO_MOBILE] = @CUSTOMER_BASEINFO_MOBILE, [CUSTOMER_BASEINFO_QQ] = @CUSTOMER_BASEINFO_QQ, [CUSTOMER_BASEINFO_FAX] = @CUSTOMER_BASEINFO_FAX, [CUSTOMER_WECHAT_NO] = @CUSTOMER_WECHAT_NO, [CUSTOMER_BASEINFO_EMAIL] = @CUSTOMER_BASEINFO_EMAIL, [CUSTOMER_BASEINFO_INTRO] = @CUSTOMER_BASEINFO_INTRO, [BASEINFO_IS_DELETED] = @BASEINFO_IS_DELETED, [BASEINFO_IS_DISPLAY] = @BASEINFO_IS_DISPLAY, [CUSTOMER_BASEINFO_RMK] = @CUSTOMER_BASEINFO_RMK, [CUSTOMER_BANK_ACCOUNT] = @CUSTOMER_BANK_ACCOUNT, [CUSTOMER_BANK_TYPE] = @CUSTOMER_BANK_TYPE, [CUSTOMER_ACCOUNT_NAME] = @CUSTOMER_ACCOUNT_NAME, [CUSTOMER_BANK_NAME] = @CUSTOMER_BANK_NAME, [CUSTOMER_BANK_CCY] = @CUSTOMER_BANK_CCY, [CUSTOMER_ALIPAY_ACCOUNT] = @CUSTOMER_ALIPAY_ACCOUNT, [CUSTOMER_PAY_INNERPWD] = @CUSTOMER_PAY_INNERPWD, [CUSTOMER_FIRST_BINDBANKDT] = @CUSTOMER_FIRST_BINDBANKDT, [CUSTOMER_FIRST_BINDALIPAYDT] = @CUSTOMER_FIRST_BINDALIPAYDT, [CUSTOMER_LAST_MDBANKDT] = @CUSTOMER_LAST_MDBANKDT, [CUSTOMER_LAST_MDALIPAYDT] = @CUSTOMER_LAST_MDALIPAYDT, [CUSTOMER_DRAWALS_ACCOUNT] = @CUSTOMER_DRAWALS_ACCOUNT, [CUSTOMER_SECDEP_ACCOUNT] = @CUSTOMER_SECDEP_ACCOUNT, [CUSTOMER_LAST_DRAWALSDT] = @CUSTOMER_LAST_DRAWALSDT, [SYS_FOR_CREFY] = @SYS_FOR_CREFY, [SYS_FOR_CREFY_DT] = @SYS_FOR_CREFY_DT, [CUSTOMER_CREFY_DT] = @CUSTOMER_CREFY_DT, [CUSTOMER_IS_CREFY] = @CUSTOMER_IS_CREFY, [CUSTOMER_CREFY_FAILD_NUM] = @CUSTOMER_CREFY_FAILD_NUM, [CUSTOMER_CREFY_LAST_DT] = @CUSTOMER_CREFY_LAST_DT, [CUSTOMER_CREFY_STATUS] = @CUSTOMER_CREFY_STATUS, [CUSTOMER_CLEAR_ALIPAY_DT] = @CUSTOMER_CLEAR_ALIPAY_DT, [DENY_REASON] = @DENY_REASON, [DOCUMENT_IMAGE] = @DOCUMENT_IMAGE, [AGENT_DISTINATION_ID] = @AGENT_DISTINATION_ID, [AGENT_CITY_ID] = @AGENT_CITY_ID, [AGENT_COUNTRY_ID] = @AGENT_COUNTRY_ID, [CUSTOMER_SERVICE_AREA] = @CUSTOMER_SERVICE_AREA, [IS_DRIVING_LICENSE] = @IS_DRIVING_LICENSE, [IS_QUALIFICATION_CERTIFICATE] = @IS_QUALIFICATION_CERTIFICATE, [IS_XINGSI_LICENSE] = @IS_XINGSI_LICENSE, [IS_TRANSPORT_CERTIFICATE] = @IS_TRANSPORT_CERTIFICATE, [IS_RECORD_CARD] = @IS_RECORD_CARD WHERE (([CUSTOMER_BASEINFO_ID] = @Original_CUSTOMER_BASEINFO_ID) AND ((@IsNull_CUSTOMER_BASEINFO_NAME = 1 AND [CUSTOMER_BASEINFO_NAME] IS NULL) OR ([CUSTOMER_BASEINFO_NAME] = @Original_CUSTOMER_BASEINFO_NAME)) AND ((@IsNull_CUSTOMER_BASEINFO_GENDER = 1 AND [CUSTOMER_BASEINFO_GENDER] IS NULL) OR ([CUSTOMER_BASEINFO_GENDER] = @Original_CUSTOMER_BASEINFO_GENDER)) AND ((@IsNull_CUSTOMER_CREDENTIALS_TYPE = 1 AND [CUSTOMER_CREDENTIALS_TYPE] IS NULL) OR ([CUSTOMER_CREDENTIALS_TYPE] = @Original_CUSTOMER_CREDENTIALS_TYPE)) AND ((@IsNull_CUSTOMER_CREDENTIALS_NO = 1 AND [CUSTOMER_CREDENTIALS_NO] IS NULL) OR ([CUSTOMER_CREDENTIALS_NO] = @Original_CUSTOMER_CREDENTIALS_NO)) AND ((@IsNull_CUSTOMER_DISTINATION_ID = 1 AND [CUSTOMER_DISTINATION_ID] IS NULL) OR ([CUSTOMER_DISTINATION_ID] = @Original_CUSTOMER_DISTINATION_ID)) AND ((@IsNull_CUSTOMER_CITY_ID = 1 AND [CUSTOMER_CITY_ID] IS NULL) OR ([CUSTOMER_CITY_ID] = @Original_CUSTOMER_CITY_ID)) AND ((@IsNull_CUSTOMER_COUNTRY_ID = 1 AND [CUSTOMER_COUNTRY_ID] IS NULL) OR ([CUSTOMER_COUNTRY_ID] = @Original_CUSTOMER_COUNTRY_ID)) AND ((@IsNull_CUSTOMER_BASEINFO_BIRTH = 1 AND [CUSTOMER_BASEINFO_BIRTH] IS NULL) OR ([CUSTOMER_BASEINFO_BIRTH] = @Original_CUSTOMER_BASEINFO_BIRTH)) AND ((@IsNull_CUSTOMER_BASEINFO_PHONE = 1 AND [CUSTOMER_BASEINFO_PHONE] IS NULL) OR ([CUSTOMER_BASEINFO_PHONE] = @Original_CUSTOMER_BASEINFO_PHONE)) AND ((@IsNull_CUSTOMER_BASEINFO_MOBILE = 1 AND [CUSTOMER_BASEINFO_MOBILE] IS NULL) OR ([CUSTOMER_BASEINFO_MOBILE] = @Original_CUSTOMER_BASEINFO_MOBILE)) AND ((@IsNull_CUSTOMER_BASEINFO_QQ = 1 AND [CUSTOMER_BASEINFO_QQ] IS NULL) OR ([CUSTOMER_BASEINFO_QQ] = @Original_CUSTOMER_BASEINFO_QQ)) AND ((@IsNull_CUSTOMER_BASEINFO_FAX = 1 AND [CUSTOMER_BASEINFO_FAX] IS NULL) OR ([CUSTOMER_BASEINFO_FAX] = @Original_CUSTOMER_BASEINFO_FAX)) AND ((@IsNull_CUSTOMER_WECHAT_NO = 1 AND [CUSTOMER_WECHAT_NO] IS NULL) OR ([CUSTOMER_WECHAT_NO] = @Original_CUSTOMER_WECHAT_NO)) AND ((@IsNull_CUSTOMER_BASEINFO_EMAIL = 1 AND [CUSTOMER_BASEINFO_EMAIL] IS NULL) OR ([CUSTOMER_BASEINFO_EMAIL] = @Original_CUSTOMER_BASEINFO_EMAIL)) AND ((@IsNull_CUSTOMER_BASEINFO_INTRO = 1 AND [CUSTOMER_BASEINFO_INTRO] IS NULL) OR ([CUSTOMER_BASEINFO_INTRO] = @Original_CUSTOMER_BASEINFO_INTRO)) AND ([BASEINFO_IS_DELETED] = @Original_BASEINFO_IS_DELETED) AND ([BASEINFO_IS_DISPLAY] = @Original_BASEINFO_IS_DISPLAY) AND ((@IsNull_CUSTOMER_BASEINFO_RMK = 1 AND [CUSTOMER_BASEINFO_RMK] IS NULL) OR ([CUSTOMER_BASEINFO_RMK] = @Original_CUSTOMER_BASEINFO_RMK)) AND ((@IsNull_CUSTOMER_BANK_ACCOUNT = 1 AND [CUSTOMER_BANK_ACCOUNT] IS NULL) OR ([CUSTOMER_BANK_ACCOUNT] = @Original_CUSTOMER_BANK_ACCOUNT)) AND ((@IsNull_CUSTOMER_BANK_TYPE = 1 AND [CUSTOMER_BANK_TYPE] IS NULL) OR ([CUSTOMER_BANK_TYPE] = @Original_CUSTOMER_BANK_TYPE)) AND ((@IsNull_CUSTOMER_ACCOUNT_NAME = 1 AND [CUSTOMER_ACCOUNT_NAME] IS NULL) OR ([CUSTOMER_ACCOUNT_NAME] = @Original_CUSTOMER_ACCOUNT_NAME)) AND ((@IsNull_CUSTOMER_BANK_NAME = 1 AND [CUSTOMER_BANK_NAME] IS NULL) OR ([CUSTOMER_BANK_NAME] = @Original_CUSTOMER_BANK_NAME)) AND ((@IsNull_CUSTOMER_BANK_CCY = 1 AND [CUSTOMER_BANK_CCY] IS NULL) OR ([CUSTOMER_BANK_CCY] = @Original_CUSTOMER_BANK_CCY)) AND ((@IsNull_CUSTOMER_ALIPAY_ACCOUNT = 1 AND [CUSTOMER_ALIPAY_ACCOUNT] IS NULL) OR ([CUSTOMER_ALIPAY_ACCOUNT] = @Original_CUSTOMER_ALIPAY_ACCOUNT)) AND ((@IsNull_CUSTOMER_PAY_INNERPWD = 1 AND [CUSTOMER_PAY_INNERPWD] IS NULL) OR ([CUSTOMER_PAY_INNERPWD] = @Original_CUSTOMER_PAY_INNERPWD)) AND ((@IsNull_CUSTOMER_FIRST_BINDBANKDT = 1 AND [CUSTOMER_FIRST_BINDBANKDT] IS NULL) OR ([CUSTOMER_FIRST_BINDBANKDT] = @Original_CUSTOMER_FIRST_BINDBANKDT)) AND ((@IsNull_CUSTOMER_FIRST_BINDALIPAYDT = 1 AND [CUSTOMER_FIRST_BINDALIPAYDT] IS NULL) OR ([CUSTOMER_FIRST_BINDALIPAYDT] = @Original_CUSTOMER_FIRST_BINDALIPAYDT)) AND ((@IsNull_CUSTOMER_LAST_MDBANKDT = 1 AND [CUSTOMER_LAST_MDBANKDT] IS NULL) OR ([CUSTOMER_LAST_MDBANKDT] = @Original_CUSTOMER_LAST_MDBANKDT)) AND ((@IsNull_CUSTOMER_LAST_MDALIPAYDT = 1 AND [CUSTOMER_LAST_MDALIPAYDT] IS NULL) OR ([CUSTOMER_LAST_MDALIPAYDT] = @Original_CUSTOMER_LAST_MDALIPAYDT)) AND ((@IsNull_CUSTOMER_DRAWALS_ACCOUNT = 1 AND [CUSTOMER_DRAWALS_ACCOUNT] IS NULL) OR ([CUSTOMER_DRAWALS_ACCOUNT] = @Original_CUSTOMER_DRAWALS_ACCOUNT)) AND ((@IsNull_CUSTOMER_SECDEP_ACCOUNT = 1 AND [CUSTOMER_SECDEP_ACCOUNT] IS NULL) OR ([CUSTOMER_SECDEP_ACCOUNT] = @Original_CUSTOMER_SECDEP_ACCOUNT)) AND ((@IsNull_CUSTOMER_LAST_DRAWALSDT = 1 AND [CUSTOMER_LAST_DRAWALSDT] IS NULL) OR ([CUSTOMER_LAST_DRAWALSDT] = @Original_CUSTOMER_LAST_DRAWALSDT)) AND ((@IsNull_SYS_FOR_CREFY = 1 AND [SYS_FOR_CREFY] IS NULL) OR ([SYS_FOR_CREFY] = @Original_SYS_FOR_CREFY)) AND ((@IsNull_SYS_FOR_CREFY_DT = 1 AND [SYS_FOR_CREFY_DT] IS NULL) OR ([SYS_FOR_CREFY_DT] = @Original_SYS_FOR_CREFY_DT)) AND ((@IsNull_CUSTOMER_CREFY_DT = 1 AND [CUSTOMER_CREFY_DT] IS NULL) OR ([CUSTOMER_CREFY_DT] = @Original_CUSTOMER_CREFY_DT)) AND ((@IsNull_CUSTOMER_IS_CREFY = 1 AND [CUSTOMER_IS_CREFY] IS NULL) OR ([CUSTOMER_IS_CREFY] = @Original_CUSTOMER_IS_CREFY)) AND ((@IsNull_CUSTOMER_CREFY_FAILD_NUM = 1 AND [CUSTOMER_CREFY_FAILD_NUM] IS NULL) OR ([CUSTOMER_CREFY_FAILD_NUM] = @Original_CUSTOMER_CREFY_FAILD_NUM)) AND ((@IsNull_CUSTOMER_CREFY_LAST_DT = 1 AND [CUSTOMER_CREFY_LAST_DT] IS NULL) OR ([CUSTOMER_CREFY_LAST_DT] = @Original_CUSTOMER_CREFY_LAST_DT)) AND ((@IsNull_CUSTOMER_CREFY_STATUS = 1 AND [CUSTOMER_CREFY_STATUS] IS NULL) OR ([CUSTOMER_CREFY_STATUS] = @Original_CUSTOMER_CREFY_STATUS)) AND ((@IsNull_CUSTOMER_CLEAR_ALIPAY_DT = 1 AND [CUSTOMER_CLEAR_ALIPAY_DT] IS NULL) OR ([CUSTOMER_CLEAR_ALIPAY_DT] = @Original_CUSTOMER_CLEAR_ALIPAY_DT)) AND ((@IsNull_DENY_REASON = 1 AND [DENY_REASON] IS NULL) OR ([DENY_REASON] = @Original_DENY_REASON)) AND ((@IsNull_DOCUMENT_IMAGE = 1 AND [DOCUMENT_IMAGE] IS NULL) OR ([DOCUMENT_IMAGE] = @Original_DOCUMENT_IMAGE)) AND ((@IsNull_AGENT_DISTINATION_ID = 1 AND [AGENT_DISTINATION_ID] IS NULL) OR ([AGENT_DISTINATION_ID] = @Original_AGENT_DISTINATION_ID)) AND ((@IsNull_AGENT_CITY_ID = 1 AND [AGENT_CITY_ID] IS NULL) OR ([AGENT_CITY_ID] = @Original_AGENT_CITY_ID)) AND ((@IsNull_AGENT_COUNTRY_ID = 1 AND [AGENT_COUNTRY_ID] IS NULL) OR ([AGENT_COUNTRY_ID] = @Original_AGENT_COUNTRY_ID)) AND ((@IsNull_CUSTOMER_SERVICE_AREA = 1 AND [CUSTOMER_SERVICE_AREA] IS NULL) OR ([CUSTOMER_SERVICE_AREA] = @Original_CUSTOMER_SERVICE_AREA)) AND ((@IsNull_IS_DRIVING_LICENSE = 1 AND [IS_DRIVING_LICENSE] IS NULL) OR ([IS_DRIVING_LICENSE] = @Original_IS_DRIVING_LICENSE)) AND ((@IsNull_IS_QUALIFICATION_CERTIFICATE = 1 AND [IS_QUALIFICATION_CERTIFICATE] IS NULL) OR ([IS_QUALIFICATION_CERTIFICATE] = @Original_IS_QUALIFICATION_CERTIFICATE)) AND ((@IsNull_IS_XINGSI_LICENSE = 1 AND [IS_XINGSI_LICENSE] IS NULL) OR ([IS_XINGSI_LICENSE] = @Original_IS_XINGSI_LICENSE)) AND ((@IsNull_IS_TRANSPORT_CERTIFICATE = 1 AND [IS_TRANSPORT_CERTIFICATE] IS NULL) OR ([IS_TRANSPORT_CERTIFICATE] = @Original_IS_TRANSPORT_CERTIFICATE)) AND ((@IsNull_IS_RECORD_CARD = 1 AND [IS_RECORD_CARD] IS NULL) OR ([IS_RECORD_CARD] = @Original_IS_RECORD_CARD)));
SELECT CUSTOMER_BASEINFO_ID, CUSTOMER_BASEINFO_NAME, CUSTOMER_BASEINFO_GENDER, CUSTOMER_CREDENTIALS_TYPE, CUSTOMER_CREDENTIALS_NO, CUSTOMER_DISTINATION_ID, CUSTOMER_CITY_ID, CUSTOMER_COUNTRY_ID, CUSTOMER_BASEINFO_BIRTH, CUSTOMER_BASEINFO_PHONE, CUSTOMER_BASEINFO_MOBILE, CUSTOMER_BASEINFO_QQ, CUSTOMER_BASEINFO_FAX, CUSTOMER_WECHAT_NO, CUSTOMER_BASEINFO_EMAIL, CUSTOMER_BASEINFO_INTRO, BASEINFO_IS_DELETED, BASEINFO_IS_DISPLAY, CUSTOMER_BASEINFO_RMK, CUSTOMER_BANK_ACCOUNT, CUSTOMER_BANK_TYPE, CUSTOMER_ACCOUNT_NAME, CUSTOMER_BANK_NAME, CUSTOMER_BANK_CCY, CUSTOMER_ALIPAY_ACCOUNT, CUSTOMER_PAY_INNERPWD, CUSTOMER_FIRST_BINDBANKDT, CUSTOMER_FIRST_BINDALIPAYDT, CUSTOMER_LAST_MDBANKDT, CUSTOMER_LAST_MDALIPAYDT, CUSTOMER_DRAWALS_ACCOUNT, CUSTOMER_SECDEP_ACCOUNT, CUSTOMER_LAST_DRAWALSDT, SYS_FOR_CREFY, SYS_FOR_CREFY_DT, CUSTOMER_CREFY_DT, CUSTOMER_IS_CREFY, CUSTOMER_CREFY_FAILD_NUM, CUSTOMER_CREFY_LAST_DT, CUSTOMER_CREFY_STATUS, CUSTOMER_CLEAR_ALIPAY_DT, DENY_REASON, DOCUMENT_IMAGE, AGENT_DISTINATION_ID, AGENT_CITY_ID, AGENT_COUNTRY_ID, CUSTOMER_SERVICE_AREA, IS_DRIVING_LICENSE, IS_QUALIFICATION_CERTIFICATE, IS_XINGSI_LICENSE, IS_TRANSPORT_CERTIFICATE, IS_RECORD_CARD FROM DJK_CUSTOMER_BASEINFO WHERE (CUSTOMER_BASEINFO_ID = @CUSTOMER_BASEINFO_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_BASEINFO_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_BASEINFO_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_BASEINFO_GENDER" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_GENDER" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CUSTOMER_CREDENTIALS_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_CREDENTIALS_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_CREDENTIALS_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_CREDENTIALS_NO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_DISTINATION_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_DISTINATION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_CITY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_CITY_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_COUNTRY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_COUNTRY_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CUSTOMER_BASEINFO_BIRTH" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_BIRTH" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_BASEINFO_PHONE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_PHONE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_BASEINFO_MOBILE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_MOBILE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_BASEINFO_QQ" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_QQ" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_BASEINFO_FAX" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_FAX" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_WECHAT_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_WECHAT_NO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_BASEINFO_EMAIL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_EMAIL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_BASEINFO_INTRO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_INTRO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@BASEINFO_IS_DELETED" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="BASEINFO_IS_DELETED" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@BASEINFO_IS_DISPLAY" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="BASEINFO_IS_DISPLAY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_BASEINFO_RMK" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_RMK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_BANK_ACCOUNT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BANK_ACCOUNT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_BANK_TYPE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BANK_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_ACCOUNT_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_ACCOUNT_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_BANK_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BANK_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CUSTOMER_BANK_CCY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BANK_CCY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_ALIPAY_ACCOUNT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_ALIPAY_ACCOUNT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_PAY_INNERPWD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_PAY_INNERPWD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CUSTOMER_FIRST_BINDBANKDT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_FIRST_BINDBANKDT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CUSTOMER_FIRST_BINDALIPAYDT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_FIRST_BINDALIPAYDT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CUSTOMER_LAST_MDBANKDT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_LAST_MDBANKDT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CUSTOMER_LAST_MDALIPAYDT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_LAST_MDALIPAYDT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CUSTOMER_DRAWALS_ACCOUNT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CUSTOMER_DRAWALS_ACCOUNT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CUSTOMER_SECDEP_ACCOUNT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CUSTOMER_SECDEP_ACCOUNT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CUSTOMER_LAST_DRAWALSDT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_LAST_DRAWALSDT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@SYS_FOR_CREFY" Precision="10" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="SYS_FOR_CREFY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@SYS_FOR_CREFY_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="SYS_FOR_CREFY_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CUSTOMER_CREFY_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_CREFY_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@CUSTOMER_IS_CREFY" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="CUSTOMER_IS_CREFY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CUSTOMER_CREFY_FAILD_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_CREFY_FAILD_NUM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CUSTOMER_CREFY_LAST_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_CREFY_LAST_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CUSTOMER_CREFY_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_CREFY_STATUS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CUSTOMER_CLEAR_ALIPAY_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_CLEAR_ALIPAY_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DENY_REASON" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DENY_REASON" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DOCUMENT_IMAGE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOCUMENT_IMAGE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AGENT_DISTINATION_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AGENT_DISTINATION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AGENT_CITY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AGENT_CITY_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AGENT_COUNTRY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AGENT_COUNTRY_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CUSTOMER_SERVICE_AREA" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_SERVICE_AREA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IS_DRIVING_LICENSE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_DRIVING_LICENSE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IS_QUALIFICATION_CERTIFICATE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_QUALIFICATION_CERTIFICATE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IS_XINGSI_LICENSE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_XINGSI_LICENSE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IS_TRANSPORT_CERTIFICATE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_TRANSPORT_CERTIFICATE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IS_RECORD_CARD" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_RECORD_CARD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_BASEINFO_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_BASEINFO_NAME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_NAME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_BASEINFO_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_BASEINFO_GENDER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_GENDER" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_BASEINFO_GENDER" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_GENDER" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_CREDENTIALS_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_CREDENTIALS_TYPE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CUSTOMER_CREDENTIALS_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_CREDENTIALS_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_CREDENTIALS_NO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_CREDENTIALS_NO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_CREDENTIALS_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_CREDENTIALS_NO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_DISTINATION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_DISTINATION_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_DISTINATION_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_DISTINATION_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_CITY_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_CITY_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_CITY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_CITY_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_COUNTRY_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_COUNTRY_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_COUNTRY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_COUNTRY_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_BASEINFO_BIRTH" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_BIRTH" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CUSTOMER_BASEINFO_BIRTH" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_BIRTH" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_BASEINFO_PHONE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_PHONE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_BASEINFO_PHONE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_PHONE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_BASEINFO_MOBILE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_MOBILE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_BASEINFO_MOBILE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_MOBILE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_BASEINFO_QQ" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_QQ" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_BASEINFO_QQ" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_QQ" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_BASEINFO_FAX" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_FAX" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_BASEINFO_FAX" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_FAX" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_WECHAT_NO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_WECHAT_NO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_WECHAT_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_WECHAT_NO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_BASEINFO_EMAIL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_EMAIL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_BASEINFO_EMAIL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_EMAIL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_BASEINFO_INTRO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_INTRO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_BASEINFO_INTRO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_INTRO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_BASEINFO_IS_DELETED" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="BASEINFO_IS_DELETED" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_BASEINFO_IS_DISPLAY" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="BASEINFO_IS_DISPLAY" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_BASEINFO_RMK" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_RMK" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_BASEINFO_RMK" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BASEINFO_RMK" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_BANK_ACCOUNT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BANK_ACCOUNT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_BANK_ACCOUNT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BANK_ACCOUNT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_BANK_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BANK_TYPE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_BANK_TYPE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BANK_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_ACCOUNT_NAME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_ACCOUNT_NAME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_ACCOUNT_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_ACCOUNT_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_BANK_NAME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BANK_NAME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_BANK_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_BANK_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_BANK_CCY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BANK_CCY" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CUSTOMER_BANK_CCY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_BANK_CCY" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_ALIPAY_ACCOUNT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_ALIPAY_ACCOUNT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_ALIPAY_ACCOUNT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_ALIPAY_ACCOUNT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_PAY_INNERPWD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_PAY_INNERPWD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_PAY_INNERPWD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_PAY_INNERPWD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_FIRST_BINDBANKDT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_FIRST_BINDBANKDT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CUSTOMER_FIRST_BINDBANKDT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_FIRST_BINDBANKDT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_FIRST_BINDALIPAYDT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_FIRST_BINDALIPAYDT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CUSTOMER_FIRST_BINDALIPAYDT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_FIRST_BINDALIPAYDT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_LAST_MDBANKDT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_LAST_MDBANKDT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CUSTOMER_LAST_MDBANKDT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_LAST_MDBANKDT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_LAST_MDALIPAYDT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_LAST_MDALIPAYDT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CUSTOMER_LAST_MDALIPAYDT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_LAST_MDALIPAYDT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_DRAWALS_ACCOUNT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_DRAWALS_ACCOUNT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CUSTOMER_DRAWALS_ACCOUNT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CUSTOMER_DRAWALS_ACCOUNT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_SECDEP_ACCOUNT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_SECDEP_ACCOUNT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CUSTOMER_SECDEP_ACCOUNT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CUSTOMER_SECDEP_ACCOUNT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_LAST_DRAWALSDT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_LAST_DRAWALSDT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CUSTOMER_LAST_DRAWALSDT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_LAST_DRAWALSDT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SYS_FOR_CREFY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SYS_FOR_CREFY" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_SYS_FOR_CREFY" Precision="10" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="SYS_FOR_CREFY" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SYS_FOR_CREFY_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SYS_FOR_CREFY_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_SYS_FOR_CREFY_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="SYS_FOR_CREFY_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_CREFY_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_CREFY_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CUSTOMER_CREFY_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_CREFY_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_IS_CREFY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_IS_CREFY" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_CUSTOMER_IS_CREFY" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="CUSTOMER_IS_CREFY" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_CREFY_FAILD_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_CREFY_FAILD_NUM" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CUSTOMER_CREFY_FAILD_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_CREFY_FAILD_NUM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_CREFY_LAST_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_CREFY_LAST_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CUSTOMER_CREFY_LAST_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_CREFY_LAST_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_CREFY_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_CREFY_STATUS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CUSTOMER_CREFY_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_CREFY_STATUS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_CLEAR_ALIPAY_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_CLEAR_ALIPAY_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CUSTOMER_CLEAR_ALIPAY_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CUSTOMER_CLEAR_ALIPAY_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DENY_REASON" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DENY_REASON" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DENY_REASON" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DENY_REASON" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DOCUMENT_IMAGE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOCUMENT_IMAGE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DOCUMENT_IMAGE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DOCUMENT_IMAGE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AGENT_DISTINATION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AGENT_DISTINATION_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AGENT_DISTINATION_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AGENT_DISTINATION_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AGENT_CITY_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AGENT_CITY_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AGENT_CITY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AGENT_CITY_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AGENT_COUNTRY_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AGENT_COUNTRY_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AGENT_COUNTRY_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AGENT_COUNTRY_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CUSTOMER_SERVICE_AREA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CUSTOMER_SERVICE_AREA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CUSTOMER_SERVICE_AREA" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CUSTOMER_SERVICE_AREA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IS_DRIVING_LICENSE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IS_DRIVING_LICENSE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IS_DRIVING_LICENSE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_DRIVING_LICENSE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IS_QUALIFICATION_CERTIFICATE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IS_QUALIFICATION_CERTIFICATE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IS_QUALIFICATION_CERTIFICATE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_QUALIFICATION_CERTIFICATE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IS_XINGSI_LICENSE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IS_XINGSI_LICENSE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IS_XINGSI_LICENSE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_XINGSI_LICENSE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IS_TRANSPORT_CERTIFICATE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IS_TRANSPORT_CERTIFICATE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IS_TRANSPORT_CERTIFICATE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_TRANSPORT_CERTIFICATE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IS_RECORD_CARD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IS_RECORD_CARD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IS_RECORD_CARD" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_RECORD_CARD" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CUSTOMER_BASEINFO_ID" DataSetColumn="CUSTOMER_BASEINFO_ID" />
              <Mapping SourceColumn="CUSTOMER_BASEINFO_NAME" DataSetColumn="CUSTOMER_BASEINFO_NAME" />
              <Mapping SourceColumn="CUSTOMER_BASEINFO_GENDER" DataSetColumn="CUSTOMER_BASEINFO_GENDER" />
              <Mapping SourceColumn="CUSTOMER_CREDENTIALS_TYPE" DataSetColumn="CUSTOMER_CREDENTIALS_TYPE" />
              <Mapping SourceColumn="CUSTOMER_CREDENTIALS_NO" DataSetColumn="CUSTOMER_CREDENTIALS_NO" />
              <Mapping SourceColumn="CUSTOMER_DISTINATION_ID" DataSetColumn="CUSTOMER_DISTINATION_ID" />
              <Mapping SourceColumn="CUSTOMER_CITY_ID" DataSetColumn="CUSTOMER_CITY_ID" />
              <Mapping SourceColumn="CUSTOMER_COUNTRY_ID" DataSetColumn="CUSTOMER_COUNTRY_ID" />
              <Mapping SourceColumn="CUSTOMER_BASEINFO_BIRTH" DataSetColumn="CUSTOMER_BASEINFO_BIRTH" />
              <Mapping SourceColumn="CUSTOMER_BASEINFO_PHONE" DataSetColumn="CUSTOMER_BASEINFO_PHONE" />
              <Mapping SourceColumn="CUSTOMER_BASEINFO_MOBILE" DataSetColumn="CUSTOMER_BASEINFO_MOBILE" />
              <Mapping SourceColumn="CUSTOMER_BASEINFO_QQ" DataSetColumn="CUSTOMER_BASEINFO_QQ" />
              <Mapping SourceColumn="CUSTOMER_BASEINFO_FAX" DataSetColumn="CUSTOMER_BASEINFO_FAX" />
              <Mapping SourceColumn="CUSTOMER_WECHAT_NO" DataSetColumn="CUSTOMER_WECHAT_NO" />
              <Mapping SourceColumn="CUSTOMER_BASEINFO_EMAIL" DataSetColumn="CUSTOMER_BASEINFO_EMAIL" />
              <Mapping SourceColumn="CUSTOMER_BASEINFO_INTRO" DataSetColumn="CUSTOMER_BASEINFO_INTRO" />
              <Mapping SourceColumn="BASEINFO_IS_DELETED" DataSetColumn="BASEINFO_IS_DELETED" />
              <Mapping SourceColumn="BASEINFO_IS_DISPLAY" DataSetColumn="BASEINFO_IS_DISPLAY" />
              <Mapping SourceColumn="CUSTOMER_BASEINFO_RMK" DataSetColumn="CUSTOMER_BASEINFO_RMK" />
              <Mapping SourceColumn="CUSTOMER_BANK_ACCOUNT" DataSetColumn="CUSTOMER_BANK_ACCOUNT" />
              <Mapping SourceColumn="CUSTOMER_BANK_TYPE" DataSetColumn="CUSTOMER_BANK_TYPE" />
              <Mapping SourceColumn="CUSTOMER_ACCOUNT_NAME" DataSetColumn="CUSTOMER_ACCOUNT_NAME" />
              <Mapping SourceColumn="CUSTOMER_BANK_NAME" DataSetColumn="CUSTOMER_BANK_NAME" />
              <Mapping SourceColumn="CUSTOMER_BANK_CCY" DataSetColumn="CUSTOMER_BANK_CCY" />
              <Mapping SourceColumn="CUSTOMER_ALIPAY_ACCOUNT" DataSetColumn="CUSTOMER_ALIPAY_ACCOUNT" />
              <Mapping SourceColumn="CUSTOMER_PAY_INNERPWD" DataSetColumn="CUSTOMER_PAY_INNERPWD" />
              <Mapping SourceColumn="CUSTOMER_FIRST_BINDBANKDT" DataSetColumn="CUSTOMER_FIRST_BINDBANKDT" />
              <Mapping SourceColumn="CUSTOMER_FIRST_BINDALIPAYDT" DataSetColumn="CUSTOMER_FIRST_BINDALIPAYDT" />
              <Mapping SourceColumn="CUSTOMER_LAST_MDBANKDT" DataSetColumn="CUSTOMER_LAST_MDBANKDT" />
              <Mapping SourceColumn="CUSTOMER_LAST_MDALIPAYDT" DataSetColumn="CUSTOMER_LAST_MDALIPAYDT" />
              <Mapping SourceColumn="CUSTOMER_DRAWALS_ACCOUNT" DataSetColumn="CUSTOMER_DRAWALS_ACCOUNT" />
              <Mapping SourceColumn="CUSTOMER_SECDEP_ACCOUNT" DataSetColumn="CUSTOMER_SECDEP_ACCOUNT" />
              <Mapping SourceColumn="CUSTOMER_LAST_DRAWALSDT" DataSetColumn="CUSTOMER_LAST_DRAWALSDT" />
              <Mapping SourceColumn="SYS_FOR_CREFY" DataSetColumn="SYS_FOR_CREFY" />
              <Mapping SourceColumn="SYS_FOR_CREFY_DT" DataSetColumn="SYS_FOR_CREFY_DT" />
              <Mapping SourceColumn="CUSTOMER_CREFY_DT" DataSetColumn="CUSTOMER_CREFY_DT" />
              <Mapping SourceColumn="CUSTOMER_IS_CREFY" DataSetColumn="CUSTOMER_IS_CREFY" />
              <Mapping SourceColumn="CUSTOMER_CREFY_FAILD_NUM" DataSetColumn="CUSTOMER_CREFY_FAILD_NUM" />
              <Mapping SourceColumn="CUSTOMER_CREFY_LAST_DT" DataSetColumn="CUSTOMER_CREFY_LAST_DT" />
              <Mapping SourceColumn="CUSTOMER_CREFY_STATUS" DataSetColumn="CUSTOMER_CREFY_STATUS" />
              <Mapping SourceColumn="CUSTOMER_CLEAR_ALIPAY_DT" DataSetColumn="CUSTOMER_CLEAR_ALIPAY_DT" />
              <Mapping SourceColumn="DENY_REASON" DataSetColumn="DENY_REASON" />
              <Mapping SourceColumn="DOCUMENT_IMAGE" DataSetColumn="DOCUMENT_IMAGE" />
              <Mapping SourceColumn="AGENT_DISTINATION_ID" DataSetColumn="AGENT_DISTINATION_ID" />
              <Mapping SourceColumn="AGENT_CITY_ID" DataSetColumn="AGENT_CITY_ID" />
              <Mapping SourceColumn="AGENT_COUNTRY_ID" DataSetColumn="AGENT_COUNTRY_ID" />
              <Mapping SourceColumn="CUSTOMER_SERVICE_AREA" DataSetColumn="CUSTOMER_SERVICE_AREA" />
              <Mapping SourceColumn="IS_DRIVING_LICENSE" DataSetColumn="IS_DRIVING_LICENSE" />
              <Mapping SourceColumn="IS_QUALIFICATION_CERTIFICATE" DataSetColumn="IS_QUALIFICATION_CERTIFICATE" />
              <Mapping SourceColumn="IS_XINGSI_LICENSE" DataSetColumn="IS_XINGSI_LICENSE" />
              <Mapping SourceColumn="IS_TRANSPORT_CERTIFICATE" DataSetColumn="IS_TRANSPORT_CERTIFICATE" />
              <Mapping SourceColumn="IS_RECORD_CARD" DataSetColumn="IS_RECORD_CARD" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="CDmDjkCustomerBaseInfo" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="CDmDjkCustomerBaseInfo" msprop:Generator_UserDSName="CDmDjkCustomerBaseInfo">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="DJK_CUSTOMER_BASEINFO" msprop:Generator_TableClassName="DJK_CUSTOMER_BASEINFODataTable" msprop:Generator_TableVarName="tableDJK_CUSTOMER_BASEINFO" msprop:Generator_TablePropName="DJK_CUSTOMER_BASEINFO" msprop:Generator_RowDeletingName="DJK_CUSTOMER_BASEINFORowDeleting" msprop:Generator_RowChangingName="DJK_CUSTOMER_BASEINFORowChanging" msprop:Generator_RowEvHandlerName="DJK_CUSTOMER_BASEINFORowChangeEventHandler" msprop:Generator_RowDeletedName="DJK_CUSTOMER_BASEINFORowDeleted" msprop:Generator_UserTableName="DJK_CUSTOMER_BASEINFO" msprop:Generator_RowChangedName="DJK_CUSTOMER_BASEINFORowChanged" msprop:Generator_RowEvArgName="DJK_CUSTOMER_BASEINFORowChangeEvent" msprop:Generator_RowClassName="DJK_CUSTOMER_BASEINFORow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CUSTOMER_BASEINFO_ID" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_BASEINFO_ID" msprop:Generator_ColumnPropNameInRow="CUSTOMER_BASEINFO_ID" msprop:Generator_ColumnPropNameInTable="CUSTOMER_BASEINFO_IDColumn" msprop:Generator_UserColumnName="CUSTOMER_BASEINFO_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUSTOMER_BASEINFO_NAME" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_BASEINFO_NAME" msprop:Generator_ColumnPropNameInRow="CUSTOMER_BASEINFO_NAME" msprop:Generator_ColumnPropNameInTable="CUSTOMER_BASEINFO_NAMEColumn" msprop:Generator_UserColumnName="CUSTOMER_BASEINFO_NAME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUSTOMER_BASEINFO_GENDER" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_BASEINFO_GENDER" msprop:Generator_ColumnPropNameInRow="CUSTOMER_BASEINFO_GENDER" msprop:Generator_ColumnPropNameInTable="CUSTOMER_BASEINFO_GENDERColumn" msprop:Generator_UserColumnName="CUSTOMER_BASEINFO_GENDER" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUSTOMER_CREDENTIALS_TYPE" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_CREDENTIALS_TYPE" msprop:Generator_ColumnPropNameInRow="CUSTOMER_CREDENTIALS_TYPE" msprop:Generator_ColumnPropNameInTable="CUSTOMER_CREDENTIALS_TYPEColumn" msprop:Generator_UserColumnName="CUSTOMER_CREDENTIALS_TYPE" type="xs:int" minOccurs="0" />
              <xs:element name="CUSTOMER_CREDENTIALS_NO" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_CREDENTIALS_NO" msprop:Generator_ColumnPropNameInRow="CUSTOMER_CREDENTIALS_NO" msprop:Generator_ColumnPropNameInTable="CUSTOMER_CREDENTIALS_NOColumn" msprop:Generator_UserColumnName="CUSTOMER_CREDENTIALS_NO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUSTOMER_DISTINATION_ID" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_DISTINATION_ID" msprop:Generator_ColumnPropNameInRow="CUSTOMER_DISTINATION_ID" msprop:Generator_ColumnPropNameInTable="CUSTOMER_DISTINATION_IDColumn" msprop:Generator_UserColumnName="CUSTOMER_DISTINATION_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUSTOMER_CITY_ID" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_CITY_ID" msprop:Generator_ColumnPropNameInRow="CUSTOMER_CITY_ID" msprop:Generator_ColumnPropNameInTable="CUSTOMER_CITY_IDColumn" msprop:Generator_UserColumnName="CUSTOMER_CITY_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUSTOMER_COUNTRY_ID" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_COUNTRY_ID" msprop:Generator_ColumnPropNameInRow="CUSTOMER_COUNTRY_ID" msprop:Generator_ColumnPropNameInTable="CUSTOMER_COUNTRY_IDColumn" msprop:Generator_UserColumnName="CUSTOMER_COUNTRY_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUSTOMER_BASEINFO_BIRTH" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_BASEINFO_BIRTH" msprop:Generator_ColumnPropNameInRow="CUSTOMER_BASEINFO_BIRTH" msprop:Generator_ColumnPropNameInTable="CUSTOMER_BASEINFO_BIRTHColumn" msprop:Generator_UserColumnName="CUSTOMER_BASEINFO_BIRTH" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CUSTOMER_BASEINFO_PHONE" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_BASEINFO_PHONE" msprop:Generator_ColumnPropNameInRow="CUSTOMER_BASEINFO_PHONE" msprop:Generator_ColumnPropNameInTable="CUSTOMER_BASEINFO_PHONEColumn" msprop:Generator_UserColumnName="CUSTOMER_BASEINFO_PHONE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="16" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUSTOMER_BASEINFO_MOBILE" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_BASEINFO_MOBILE" msprop:Generator_ColumnPropNameInRow="CUSTOMER_BASEINFO_MOBILE" msprop:Generator_ColumnPropNameInTable="CUSTOMER_BASEINFO_MOBILEColumn" msprop:Generator_UserColumnName="CUSTOMER_BASEINFO_MOBILE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUSTOMER_BASEINFO_QQ" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_BASEINFO_QQ" msprop:Generator_ColumnPropNameInRow="CUSTOMER_BASEINFO_QQ" msprop:Generator_ColumnPropNameInTable="CUSTOMER_BASEINFO_QQColumn" msprop:Generator_UserColumnName="CUSTOMER_BASEINFO_QQ" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUSTOMER_BASEINFO_FAX" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_BASEINFO_FAX" msprop:Generator_ColumnPropNameInRow="CUSTOMER_BASEINFO_FAX" msprop:Generator_ColumnPropNameInTable="CUSTOMER_BASEINFO_FAXColumn" msprop:Generator_UserColumnName="CUSTOMER_BASEINFO_FAX" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUSTOMER_WECHAT_NO" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_WECHAT_NO" msprop:Generator_ColumnPropNameInRow="CUSTOMER_WECHAT_NO" msprop:Generator_ColumnPropNameInTable="CUSTOMER_WECHAT_NOColumn" msprop:Generator_UserColumnName="CUSTOMER_WECHAT_NO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUSTOMER_BASEINFO_EMAIL" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_BASEINFO_EMAIL" msprop:Generator_ColumnPropNameInRow="CUSTOMER_BASEINFO_EMAIL" msprop:Generator_ColumnPropNameInTable="CUSTOMER_BASEINFO_EMAILColumn" msprop:Generator_UserColumnName="CUSTOMER_BASEINFO_EMAIL" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUSTOMER_BASEINFO_INTRO" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_BASEINFO_INTRO" msprop:Generator_ColumnPropNameInRow="CUSTOMER_BASEINFO_INTRO" msprop:Generator_ColumnPropNameInTable="CUSTOMER_BASEINFO_INTROColumn" msprop:Generator_UserColumnName="CUSTOMER_BASEINFO_INTRO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BASEINFO_IS_DELETED" msprop:Generator_ColumnVarNameInTable="columnBASEINFO_IS_DELETED" msprop:Generator_ColumnPropNameInRow="BASEINFO_IS_DELETED" msprop:Generator_ColumnPropNameInTable="BASEINFO_IS_DELETEDColumn" msprop:Generator_UserColumnName="BASEINFO_IS_DELETED" type="xs:boolean" />
              <xs:element name="BASEINFO_IS_DISPLAY" msprop:Generator_ColumnVarNameInTable="columnBASEINFO_IS_DISPLAY" msprop:Generator_ColumnPropNameInRow="BASEINFO_IS_DISPLAY" msprop:Generator_ColumnPropNameInTable="BASEINFO_IS_DISPLAYColumn" msprop:Generator_UserColumnName="BASEINFO_IS_DISPLAY" type="xs:boolean" />
              <xs:element name="CUSTOMER_BASEINFO_RMK" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_BASEINFO_RMK" msprop:Generator_ColumnPropNameInRow="CUSTOMER_BASEINFO_RMK" msprop:Generator_ColumnPropNameInTable="CUSTOMER_BASEINFO_RMKColumn" msprop:Generator_UserColumnName="CUSTOMER_BASEINFO_RMK" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUSTOMER_BANK_ACCOUNT" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_BANK_ACCOUNT" msprop:Generator_ColumnPropNameInRow="CUSTOMER_BANK_ACCOUNT" msprop:Generator_ColumnPropNameInTable="CUSTOMER_BANK_ACCOUNTColumn" msprop:Generator_UserColumnName="CUSTOMER_BANK_ACCOUNT" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUSTOMER_BANK_TYPE" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_BANK_TYPE" msprop:Generator_ColumnPropNameInRow="CUSTOMER_BANK_TYPE" msprop:Generator_ColumnPropNameInTable="CUSTOMER_BANK_TYPEColumn" msprop:Generator_UserColumnName="CUSTOMER_BANK_TYPE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUSTOMER_ACCOUNT_NAME" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_ACCOUNT_NAME" msprop:Generator_ColumnPropNameInRow="CUSTOMER_ACCOUNT_NAME" msprop:Generator_ColumnPropNameInTable="CUSTOMER_ACCOUNT_NAMEColumn" msprop:Generator_UserColumnName="CUSTOMER_ACCOUNT_NAME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUSTOMER_BANK_NAME" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_BANK_NAME" msprop:Generator_ColumnPropNameInRow="CUSTOMER_BANK_NAME" msprop:Generator_ColumnPropNameInTable="CUSTOMER_BANK_NAMEColumn" msprop:Generator_UserColumnName="CUSTOMER_BANK_NAME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUSTOMER_BANK_CCY" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_BANK_CCY" msprop:Generator_ColumnPropNameInRow="CUSTOMER_BANK_CCY" msprop:Generator_ColumnPropNameInTable="CUSTOMER_BANK_CCYColumn" msprop:Generator_UserColumnName="CUSTOMER_BANK_CCY" type="xs:int" minOccurs="0" />
              <xs:element name="CUSTOMER_ALIPAY_ACCOUNT" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_ALIPAY_ACCOUNT" msprop:Generator_ColumnPropNameInRow="CUSTOMER_ALIPAY_ACCOUNT" msprop:Generator_ColumnPropNameInTable="CUSTOMER_ALIPAY_ACCOUNTColumn" msprop:Generator_UserColumnName="CUSTOMER_ALIPAY_ACCOUNT" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUSTOMER_PAY_INNERPWD" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_PAY_INNERPWD" msprop:Generator_ColumnPropNameInRow="CUSTOMER_PAY_INNERPWD" msprop:Generator_ColumnPropNameInTable="CUSTOMER_PAY_INNERPWDColumn" msprop:Generator_UserColumnName="CUSTOMER_PAY_INNERPWD" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUSTOMER_FIRST_BINDBANKDT" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_FIRST_BINDBANKDT" msprop:Generator_ColumnPropNameInRow="CUSTOMER_FIRST_BINDBANKDT" msprop:Generator_ColumnPropNameInTable="CUSTOMER_FIRST_BINDBANKDTColumn" msprop:Generator_UserColumnName="CUSTOMER_FIRST_BINDBANKDT" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CUSTOMER_FIRST_BINDALIPAYDT" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_FIRST_BINDALIPAYDT" msprop:Generator_ColumnPropNameInRow="CUSTOMER_FIRST_BINDALIPAYDT" msprop:Generator_ColumnPropNameInTable="CUSTOMER_FIRST_BINDALIPAYDTColumn" msprop:Generator_UserColumnName="CUSTOMER_FIRST_BINDALIPAYDT" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CUSTOMER_LAST_MDBANKDT" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_LAST_MDBANKDT" msprop:Generator_ColumnPropNameInRow="CUSTOMER_LAST_MDBANKDT" msprop:Generator_ColumnPropNameInTable="CUSTOMER_LAST_MDBANKDTColumn" msprop:Generator_UserColumnName="CUSTOMER_LAST_MDBANKDT" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CUSTOMER_LAST_MDALIPAYDT" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_LAST_MDALIPAYDT" msprop:Generator_ColumnPropNameInRow="CUSTOMER_LAST_MDALIPAYDT" msprop:Generator_ColumnPropNameInTable="CUSTOMER_LAST_MDALIPAYDTColumn" msprop:Generator_UserColumnName="CUSTOMER_LAST_MDALIPAYDT" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CUSTOMER_DRAWALS_ACCOUNT" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_DRAWALS_ACCOUNT" msprop:Generator_ColumnPropNameInRow="CUSTOMER_DRAWALS_ACCOUNT" msprop:Generator_ColumnPropNameInTable="CUSTOMER_DRAWALS_ACCOUNTColumn" msprop:Generator_UserColumnName="CUSTOMER_DRAWALS_ACCOUNT" type="xs:decimal" minOccurs="0" />
              <xs:element name="CUSTOMER_SECDEP_ACCOUNT" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_SECDEP_ACCOUNT" msprop:Generator_ColumnPropNameInRow="CUSTOMER_SECDEP_ACCOUNT" msprop:Generator_ColumnPropNameInTable="CUSTOMER_SECDEP_ACCOUNTColumn" msprop:Generator_UserColumnName="CUSTOMER_SECDEP_ACCOUNT" type="xs:decimal" minOccurs="0" />
              <xs:element name="CUSTOMER_LAST_DRAWALSDT" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_LAST_DRAWALSDT" msprop:Generator_ColumnPropNameInRow="CUSTOMER_LAST_DRAWALSDT" msprop:Generator_ColumnPropNameInTable="CUSTOMER_LAST_DRAWALSDTColumn" msprop:Generator_UserColumnName="CUSTOMER_LAST_DRAWALSDT" type="xs:dateTime" minOccurs="0" />
              <xs:element name="SYS_FOR_CREFY" msprop:Generator_ColumnVarNameInTable="columnSYS_FOR_CREFY" msprop:Generator_ColumnPropNameInRow="SYS_FOR_CREFY" msprop:Generator_ColumnPropNameInTable="SYS_FOR_CREFYColumn" msprop:Generator_UserColumnName="SYS_FOR_CREFY" type="xs:decimal" minOccurs="0" />
              <xs:element name="SYS_FOR_CREFY_DT" msprop:Generator_ColumnVarNameInTable="columnSYS_FOR_CREFY_DT" msprop:Generator_ColumnPropNameInRow="SYS_FOR_CREFY_DT" msprop:Generator_ColumnPropNameInTable="SYS_FOR_CREFY_DTColumn" msprop:Generator_UserColumnName="SYS_FOR_CREFY_DT" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CUSTOMER_CREFY_DT" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_CREFY_DT" msprop:Generator_ColumnPropNameInRow="CUSTOMER_CREFY_DT" msprop:Generator_ColumnPropNameInTable="CUSTOMER_CREFY_DTColumn" msprop:Generator_UserColumnName="CUSTOMER_CREFY_DT" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CUSTOMER_IS_CREFY" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_IS_CREFY" msprop:Generator_ColumnPropNameInRow="CUSTOMER_IS_CREFY" msprop:Generator_ColumnPropNameInTable="CUSTOMER_IS_CREFYColumn" msprop:Generator_UserColumnName="CUSTOMER_IS_CREFY" type="xs:boolean" minOccurs="0" />
              <xs:element name="CUSTOMER_CREFY_FAILD_NUM" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_CREFY_FAILD_NUM" msprop:Generator_ColumnPropNameInRow="CUSTOMER_CREFY_FAILD_NUM" msprop:Generator_ColumnPropNameInTable="CUSTOMER_CREFY_FAILD_NUMColumn" msprop:Generator_UserColumnName="CUSTOMER_CREFY_FAILD_NUM" type="xs:int" minOccurs="0" />
              <xs:element name="CUSTOMER_CREFY_LAST_DT" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_CREFY_LAST_DT" msprop:Generator_ColumnPropNameInRow="CUSTOMER_CREFY_LAST_DT" msprop:Generator_ColumnPropNameInTable="CUSTOMER_CREFY_LAST_DTColumn" msprop:Generator_UserColumnName="CUSTOMER_CREFY_LAST_DT" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CUSTOMER_CREFY_STATUS" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_CREFY_STATUS" msprop:Generator_ColumnPropNameInRow="CUSTOMER_CREFY_STATUS" msprop:Generator_ColumnPropNameInTable="CUSTOMER_CREFY_STATUSColumn" msprop:Generator_UserColumnName="CUSTOMER_CREFY_STATUS" type="xs:int" minOccurs="0" />
              <xs:element name="CUSTOMER_CLEAR_ALIPAY_DT" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_CLEAR_ALIPAY_DT" msprop:Generator_ColumnPropNameInRow="CUSTOMER_CLEAR_ALIPAY_DT" msprop:Generator_ColumnPropNameInTable="CUSTOMER_CLEAR_ALIPAY_DTColumn" msprop:Generator_UserColumnName="CUSTOMER_CLEAR_ALIPAY_DT" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DENY_REASON" msprop:Generator_ColumnVarNameInTable="columnDENY_REASON" msprop:Generator_ColumnPropNameInRow="DENY_REASON" msprop:Generator_ColumnPropNameInTable="DENY_REASONColumn" msprop:Generator_UserColumnName="DENY_REASON" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOCUMENT_IMAGE" msprop:Generator_ColumnVarNameInTable="columnDOCUMENT_IMAGE" msprop:Generator_ColumnPropNameInRow="DOCUMENT_IMAGE" msprop:Generator_ColumnPropNameInTable="DOCUMENT_IMAGEColumn" msprop:Generator_UserColumnName="DOCUMENT_IMAGE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AGENT_DISTINATION_ID" msprop:Generator_ColumnVarNameInTable="columnAGENT_DISTINATION_ID" msprop:Generator_ColumnPropNameInRow="AGENT_DISTINATION_ID" msprop:Generator_ColumnPropNameInTable="AGENT_DISTINATION_IDColumn" msprop:Generator_UserColumnName="AGENT_DISTINATION_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AGENT_CITY_ID" msprop:Generator_ColumnVarNameInTable="columnAGENT_CITY_ID" msprop:Generator_ColumnPropNameInRow="AGENT_CITY_ID" msprop:Generator_ColumnPropNameInTable="AGENT_CITY_IDColumn" msprop:Generator_UserColumnName="AGENT_CITY_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AGENT_COUNTRY_ID" msprop:Generator_ColumnVarNameInTable="columnAGENT_COUNTRY_ID" msprop:Generator_ColumnPropNameInRow="AGENT_COUNTRY_ID" msprop:Generator_ColumnPropNameInTable="AGENT_COUNTRY_IDColumn" msprop:Generator_UserColumnName="AGENT_COUNTRY_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUSTOMER_SERVICE_AREA" msprop:Generator_ColumnVarNameInTable="columnCUSTOMER_SERVICE_AREA" msprop:Generator_ColumnPropNameInRow="CUSTOMER_SERVICE_AREA" msprop:Generator_ColumnPropNameInTable="CUSTOMER_SERVICE_AREAColumn" msprop:Generator_UserColumnName="CUSTOMER_SERVICE_AREA" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IS_DRIVING_LICENSE" msprop:Generator_ColumnVarNameInTable="columnIS_DRIVING_LICENSE" msprop:Generator_ColumnPropNameInRow="IS_DRIVING_LICENSE" msprop:Generator_ColumnPropNameInTable="IS_DRIVING_LICENSEColumn" msprop:Generator_UserColumnName="IS_DRIVING_LICENSE" type="xs:boolean" minOccurs="0" />
              <xs:element name="IS_QUALIFICATION_CERTIFICATE" msprop:Generator_ColumnVarNameInTable="columnIS_QUALIFICATION_CERTIFICATE" msprop:Generator_ColumnPropNameInRow="IS_QUALIFICATION_CERTIFICATE" msprop:Generator_ColumnPropNameInTable="IS_QUALIFICATION_CERTIFICATEColumn" msprop:Generator_UserColumnName="IS_QUALIFICATION_CERTIFICATE" type="xs:boolean" minOccurs="0" />
              <xs:element name="IS_XINGSI_LICENSE" msprop:Generator_ColumnVarNameInTable="columnIS_XINGSI_LICENSE" msprop:Generator_ColumnPropNameInRow="IS_XINGSI_LICENSE" msprop:Generator_ColumnPropNameInTable="IS_XINGSI_LICENSEColumn" msprop:Generator_UserColumnName="IS_XINGSI_LICENSE" type="xs:boolean" minOccurs="0" />
              <xs:element name="IS_TRANSPORT_CERTIFICATE" msprop:Generator_ColumnVarNameInTable="columnIS_TRANSPORT_CERTIFICATE" msprop:Generator_ColumnPropNameInRow="IS_TRANSPORT_CERTIFICATE" msprop:Generator_ColumnPropNameInTable="IS_TRANSPORT_CERTIFICATEColumn" msprop:Generator_UserColumnName="IS_TRANSPORT_CERTIFICATE" type="xs:boolean" minOccurs="0" />
              <xs:element name="IS_RECORD_CARD" msprop:Generator_ColumnVarNameInTable="columnIS_RECORD_CARD" msprop:Generator_ColumnPropNameInRow="IS_RECORD_CARD" msprop:Generator_ColumnPropNameInTable="IS_RECORD_CARDColumn" msprop:Generator_UserColumnName="IS_RECORD_CARD" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DJK_CUSTOMER_BASEINFO" />
      <xs:field xpath="mstns:CUSTOMER_BASEINFO_ID" />
    </xs:unique>
  </xs:element>
</xs:schema>